package com.sms.jdbc;

public class SmsSendSql {
	public static final String getSmsSendList = "select t.* from sms_send_n t where rownum<=? and(?>= TIME_LIMIT_START and ?<=TIME_LIMIT_END) or (TIME_LIMIT_START='' and TIME_LIMIT_END='')" +
						" or (TIME_LIMIT_START is NULL and TIME_LIMIT_END is NULL)  order by sms_create_time";
	public static final String getSmsClockList = "select t.* from sms_clock t where rownum<=? and sms_send_time<= ? and ((?>= TIME_LIMIT_START and ?<=TIME_LIMIT_END) or (TIME_LIMIT_START='' and TIME_LIMIT_END='')" +
						" or (TIME_LIMIT_START is NULL and TIME_LIMIT_END is NULL)) order by sms_send_time";
}
